Author: Robert Chang @_rchang
Academically…
Professionally…
There are many open definitions:
All startups and companies want to make money, become cash positive, and see millions of users using their services. We need to measure against ourselves
How many users churned in each country on 03/01/2015?
select
country_id, count(distinct user_id)
from
(
SELECT
'2015-03-01' AS created_date, user_id, country_id, deactivated
FROM growth_staging.full_compact_snapshot_staging
WHERE created_date = '2015-03-01'
AND NOT today_mau
AND yday_mau
AND NOT suspended
) churned_mau_daily
where created_date = '2015-03-01' and deactivated = 0
group by country_id
order by country_id;
Ok, but this only answered one question, not very efficient
/
#